[dbo].[asi_FindUnreceiptedPayments]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_FindUnreceiptedPayments

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@contactKey	uniqueidentifier	16

SQL Script

CREATE PROCEDURE [dbo].[asi_FindUnreceiptedPayments]
@contactKey uniqueidentifier

AS

SELECT * FROM PaymentMain p
LEFT OUTER JOIN ReceiptLine rl on p.PaymentKey = rl.PaymentKey
WHERE p.PayorContactKey = @contactKey
AND rl.ReceiptLineKey is null

GO

Uses

[dbo].[PaymentMain]
[dbo].[ReceiptLine]
dbo